package com.tqjc.business.interactivewithscan.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.tqjc.business.interactivewithscan.entity.DeviceAction;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @program: C20005_Xianggang_new
 * @description: 动作Mapper
 * @author: Patienyon
 * @create: 2023-11-01 19:29
 **/
public interface DeviceActionMapper extends BaseMapper<DeviceAction> {

    /**
     * 查询设备动作详情
     *
     * @param actionOid
     * @return
     */

    @Select("SELECT da.device_action_oid,da.ranking,da.operation_name,da.state,da.del,da.create_time FROM ufc_device_action AS da WHERE da.device_action_oid = #{actionOid}")
    DeviceAction queryActionByOid(@Param("actionOid")Long actionOid);
}